MacWorld 1996 July/Macworld (1996-07).dmg/System 7.5 Update 2.0/FileMaker Pro 3.0 CD Extras/FileMaker Templates/Business/Expense Report

FileMaker Pro Database | 1996-01-25 | 133KB | 908 lines

HBAM2016AUG95
Pro 3.0
Orders
Party
Personnel
Photo
Planning
Product
Project
Projects
Purchase
Receipts
Recipes
Records
Jennifer HendersonI
10/13/95J
OpenL
Michael EllardM
Paul FarrahN
FailO
FixedS
10/18/95W
10/24/95Y
Michael Ellard_
10/27/95b
Names and Addressesc
Franz Filesd
Regressed:f
Suggested Fix
A8- default font for Info field on Info layout incorrect.
All LayoutsD
Jennifer HendersonI
10/13/95J
ClosedL
Michael EllardM
Paul FarrahN
PassO
FixedS
10/18/95W
10/24/95Y
Michael Ellard_
10/24/95b
Party & Wedding Planningc
Franz Filesd
Regressed:
HBAM3016AUG95
Pro 2.0 - 2.1F!
Pro 3.0
    Franz App
AMOUNT 1
AMOUNT 2
AMOUNT 3
AMOUNT 4
AMOUNT 5
AMOUNT 6
AMOUNT 7
AMOUNT REIMB
APPROVED BY
CREATED BY
DATE 1
DATE 2
DATE 3
DATE 4
DATE 5
DATE 6
DATE 7
DATE APPROVED
DATE CREATED
DATE EMP SIGNED
DATE MODIFIED
DATE OF END OF WEEK
DATE REIMBURSED
DEPARTMENT
EMPLOYEE ID
EXPENSE RPRT ID
EXPENSE TYPE
@    EXTENSION
FIRST NAME
GRAND TOTAL
e    LAST NAME
MILE 1
MILE 2
MILE 3
MILE 4
MILE 5
MILE 6
MILE 7
MILE DOLLARS 1
MILE DOLLARS 2
MILE DOLLARS 3
MILE DOLLARS 4
MILE DOLLARS 5
MILE DOLLARS 6
MILE DOLLARS 7
PROJECT
PURPOSE OF TRIP
RATE PER MILE
SUBTOTAL 1
SUBTOTAL 2
SUBTOTAL 3
SUBTOTAL 4
SUBTOTAL 5
SUBTOTAL 6
SUBTOTAL 7
SUBTTL MILE AMNT
SUBTTLS WEEK
Sunday
Monday
Tuesday
    Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
    September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
11/20/95
Expense Rprt IDB
Date CreatedB
Date ModifiedB
Date 1B
3 - 6
Date 2B
3 - 5
Date 3B
3 - 4
Date 4B
3 - 3
Date 5B
3 - 2
Date of End of WeekB
Date 6B
3 - 1
Amount 1B
Amount 2B
Amount 3B
Amount 4B
Amount 5B
Amount 6B
Amount 7B
Employee IDB
First NameB
?A    Last NameB
Expense TypeB
Subtotal 1B
5) +
Subtotal 2B
6) +
Subtotal 3B
7) +
Subtotal 4B
8) +
Subtotal 5B
9) +
Subtotal 6B
;) +
Subtotal 7B
<) +
Description
This file contains all the line items on an invoice. It can be used by itself, but it is intended to be used as a relational database with the Purchase Order template. By keeping the line items in a separate file, you have more flexibility than you would if you used a repeating field.
How to use this solution
Each invoice should have one P.O. number. This number groups all the line items in the invoice. Later, you can search on this number (or use a relation from another datab
ase) to print an invoice.
Run the Purchase Order report to see an example invoice.
How to customize this solution
You can integrate this database with several other databases in a relational scheme. An Invoices database could organize the invoices, using customer information from a Customers database. A Parts or Products database could be linked to the Part No. field, so that the description and price are entered automatically.
Grand TotalB
Q) +
Rate per MileB
Mile 1B
Mile 2B
Mile 3B
Mile 4B
Mile 5B
Mile 6B
Mile 7B
Subttls WeekB
Date 7B
Mile Dollars 1B
Mile Dollars 2B
Mile Dollars 3B
Mile Dollars 4B
Mile Dollars 5B
Mile Dollars 6B
Mile Dollars 7B
Subttl Mile AmntB
DepartmentB
ProjectB
Purpose of TripB
Created ByB
Date ReimbursedB
Amount ReimbB
Date Emp SignedB
Approved ByB
Date ApprovedB
dA    ExtensionB
InfoB
A    Form View
A    List View
Expense Report
Information
Report Menu
A    Form ViewB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
A    List ViewB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Your Own
Button
Your Own
Button
Record
Delete
Record
Record
Reports
View As
View As
Close
Totals:
Miles:
Date:
Totals
Amount
Date Reimbursed
Purpose of Trip
Project
Dept.
Rate/
Week Ending
~    Extension
    Last Name
First Name
Emp. ID
    Report ID
Enter data for Expenses
Expense ReportB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Amount`
Reimb.a
Totalb
Weekc    Last Named
First Namee    Report IDf
Your Own
Buttong
Your Own
Buttonh
Recordi
Delete
Recordj
Recordk
Reportsl
View As
Listm
View As
Formn
Closeo
Infop3Click to see more information for an Expense Report
InformationB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Your Own
Button
Reports
View As
View As
Close
Rev. 09/17/95
z<Please return completed form to accounts payable department.
Manager Signature
Employee Signature
Date Reimbursed
Amount Reimb
Totals:
Miles:
Totals
Dates:
    Rate/Mile
Purpose of Trip
Project
Dept.
Emp. ID
    Last Name
First Name
Week Ending
    Report ID
Expense Report
Company Name and Logo
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO.Information about the Expense Reports solutionP
Info for this Solution
Your Own
ReportB
Your Own
ReportC
Your Own ReportD
Expense ReportE
Your Own
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
    Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
UETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Sort by Last Name
Sort by Date of End of Week
Open Script
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C)
Cancel
No records match this request.
Sort by Expense Report ID
Sort by Last Name
Sort by Date of End of Week
Expense Report
Open Script
Sort by Expense Report ID
Expense Report
Ejwwg
wwxwwxw
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
(LIST
LISTA
Auto Rental
Tolls and Parking
Air, Rail, Bus
Taxi, Limousine
Lodging
Telephone
Personal Meals
Banquet Meals
Business Meals
Entertainment
VDEFA(
(LIST
VDEFA(
Expense Type ListB
Project List
wwwwww
    ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
wwwwww
    ffffff
UUUUUU
DDDDDD
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
"    234DUfw
2""2334DEVgx
3    4DEUfwx
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
"%UR
UD33D
3    DDUVgw
D    EUUfwx
UDDEUUfgw
U    Vfgwx
eUVfgww
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
AD@D@
AD@D@
44444
CCCCC 44444 CCCCC
$42"
@@BA@
bRBBP0
UUUUU
 JJJJ
!BBBB
"99BB
#9999
$9911
%1111
&))))C
'!!!!
 *00**-
*00-00
00*0)
00*&0#
## !0*!%00+#!*0##-0'"0*#%00.!
(*)(%,3&
)%+@6)
",30,)%
UUUUUU
wwwwww
 #*>A6332+$"!
25,878
#&$690*"
!)0,++)(
 "%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*,1!
!$&(265389,#!$$
'275?
$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<H
/2583$%+66/%
 %)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
 $$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
 !$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!L
//6B&
 #'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+N
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//O
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!P
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%
&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.R
94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGS
CA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<3)"
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
 %'0>GFA:378+&&%$$,&
,:CPQ
$(,0V
27CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
 #%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
6=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,Z
*3*)-/0/+&$$!
 6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7[
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
 &46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
 #'21\
.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww